<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title> Operator Index</title>
<link rel="stylesheet" href="mvl.css" type="text/css" />
<meta name="generator" content="DocBook XSL Stylesheets + chunker.py v1.9.2" />
<link rel="start" href="index.html" title="{book-title}" />
<link rel="up" href="" title="" />
<link rel="prev" href="dynindex-jointype.html" title=" Join Types Index" />
<link rel="next" href="dynindex-option.html" title=" Option Index" />
</head>
<body bgcolor="white" text="black" link="#0000FF" vlink="#840084" alink="#0000FF">
<div class="navheader">
<table width="100%" summary="Navigation header">
<tr>
<th colspan="3" align="center"> Operator Index</th>
</tr>
<tr>
<td width="20%" align="left"><a accesskey="p" href="dynindex-jointype.html">Prev</a> </td>
<th width="60%" align="center"></th>
<td width="20%" align="right"> <a accesskey="n" href="dynindex-option.html">Next</a></td>
</tr>
</table>
<hr>
</div>
<div class="index">

<div class="titlepage">
<div>
<div>
<h2 class="title"><a name="dynindex-operator"></a>Operator Index</h2>

</div>

</div>

</div>
<p><a name="op-index-top"></a><a class="link" href="dynindex-operator.html#op-index-Symbols" title="Symbols">Symbols</a> | <a class="link" href="dynindex-operator.html#op-index-A" title="A">A</a> | <a class="link" href="dynindex-operator.html#op-index-B" title="B">B</a> | <a class="link" href="dynindex-operator.html#op-index-C" title="C">C</a> | <a class="link" href="dynindex-operator.html#op-index-D" title="D">D</a> | <a class="link" href="dynindex-operator.html#op-index-E" title="E">E</a> | <a class="link" href="dynindex-operator.html#op-index-I" title="I">I</a> | <a class="link" href="dynindex-operator.html#op-index-L" title="L">L</a> | <a class="link" href="dynindex-operator.html#op-index-N" title="N">N</a> | <a class="link" href="dynindex-operator.html#op-index-O" title="O">O</a> | <a class="link" href="dynindex-operator.html#op-index-R" title="R">R</a> | <a class="link" href="dynindex-operator.html#op-index-X" title="X">X</a></p>
<div class="indexdiv">
<a name="op-index-Symbols"></a><h3 class="title">Symbols</h3>
<p>[<a class="link" href="dynindex-operator.html#op-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">-</h3>
<dl><dt><a class="xref" href="functions.html#arithmetic-functions" title="12.6.1 Arithmetic Operators">Section 12.6.1, “Arithmetic Operators”</a></dt><dd></dd><dt><a class="xref" href="functions.html#cast-functions" title="12.10 Cast Functions and Operators">Section 12.10, “Cast Functions and Operators”</a></dt><dd></dd><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#numeric-type-overview" title="11.1.1 Numeric Type Overview">Section 11.1.1, “Numeric Type Overview”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-limitations" title="22.6 Restrictions and Limitations on Partitioning">Section 22.6, “Restrictions and Limitations on Partitioning”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">!</h3>
<dl><dt><a class="xref" href="language-structure.html#expressions" title="9.5 Expression Syntax">Section 9.5, “Expression Syntax”</a></dt><dd></dd><dt><a class="xref" href="functions.html#logical-operators" title="12.3.3 Logical Operators">Section 12.3.3, “Logical Operators”</a></dt><dd></dd><dt><a class="xref" href="functions.html#operator-precedence" title="12.3.1 Operator Precedence">Section 12.3.1, “Operator Precedence”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">!=</h3>
<dl><dt><a class="xref" href="functions.html#comparison-operators" title="12.3.2 Comparison Functions and Operators">Section 12.3.2, “Comparison Functions and Operators”</a></dt><dd></dd><dt><a class="xref" href="functions.html#operator-precedence" title="12.3.1 Operator Precedence">Section 12.3.1, “Operator Precedence”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#range-optimization" title="8.2.1.2 Range Optimization">Section 8.2.1.2, “Range Optimization”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#json" title="11.6 The JSON Data Type">Section 11.6, “The JSON Data Type”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">%</h3>
<dl><dt><a class="xref" href="functions.html#arithmetic-functions" title="12.6.1 Arithmetic Operators">Section 12.6.1, “Arithmetic Operators”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">&amp;</h3>
<dl><dt><a class="xref" href="functions.html#bit-functions" title="12.12 Bit Functions and Operators">Section 12.12, “Bit Functions and Operators”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#create-table" title="13.1.18 CREATE TABLE Syntax">Section 13.1.18, “CREATE TABLE Syntax”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-limitations" title="22.6 Restrictions and Limitations on Partitioning">Section 22.6, “Restrictions and Limitations on Partitioning”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">&amp;&amp;</h3>
<dl><dt><a class="xref" href="functions.html#logical-operators" title="12.3.3 Logical Operators">Section 12.3.3, “Logical Operators”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#extensions-to-ansi" title="1.8.1 MySQL Extensions to Standard SQL">Section 1.8.1, “MySQL Extensions to Standard SQL”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">&gt;</h3>
<dl><dt><a class="xref" href="functions.html#comparison-operators" title="12.3.2 Comparison Functions and Operators">Section 12.3.2, “Comparison Functions and Operators”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#index-btree-hash" title="8.3.9 Comparison of B-Tree and Hash Indexes">Section 8.3.9, “Comparison of B-Tree and Hash Indexes”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#explain-output" title="8.8.2 EXPLAIN Output Format">Section 8.8.2, “EXPLAIN Output Format”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#extensions-to-ansi" title="1.8.1 MySQL Extensions to Standard SQL">Section 1.8.1, “MySQL Extensions to Standard SQL”</a></dt><dd></dd><dt><a class="xref" href="functions.html#operator-precedence" title="12.3.1 Operator Precedence">Section 12.3.1, “Operator Precedence”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#generated-column-index-optimizations" title="8.3.11 Optimizer Use of Generated Column Indexes">Section 8.3.11, “Optimizer Use of Generated Column Indexes”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#range-optimization" title="8.2.1.2 Range Optimization">Section 8.2.1.2, “Range Optimization”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#json" title="11.6 The JSON Data Type">Section 11.6, “The JSON Data Type”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">-&gt;</h3>
<dl><dt><a class="xref" href="functions.html#json-search-functions" title="12.16.3 Functions That Search JSON Values">Section 12.16.3, “Functions That Search JSON Values”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#create-table-secondary-indexes" title="13.1.18.9 Secondary Indexes and Generated Columns">Section 13.1.18.9, “Secondary Indexes and Generated Columns”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#json" title="11.6 The JSON Data Type">Section 11.6, “The JSON Data Type”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#mysql-nutshell" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">&gt;&gt;</h3>
<dl><dt><a class="xref" href="functions.html#bit-functions" title="12.12 Bit Functions and Operators">Section 12.12, “Bit Functions and Operators”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#extensions-to-ansi" title="1.8.1 MySQL Extensions to Standard SQL">Section 1.8.1, “MySQL Extensions to Standard SQL”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-limitations" title="22.6 Restrictions and Limitations on Partitioning">Section 22.6, “Restrictions and Limitations on Partitioning”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">-&gt;&gt;</h3>
<dl><dt><a class="xref" href="sql-syntax.html#create-table-secondary-indexes" title="13.1.18.9 Secondary Indexes and Generated Columns">Section 13.1.18.9, “Secondary Indexes and Generated Columns”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#json" title="11.6 The JSON Data Type">Section 11.6, “The JSON Data Type”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#mysql-nutshell" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">&gt;=</h3>
<dl><dt><a class="xref" href="functions.html#comparison-operators" title="12.3.2 Comparison Functions and Operators">Section 12.3.2, “Comparison Functions and Operators”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#index-btree-hash" title="8.3.9 Comparison of B-Tree and Hash Indexes">Section 8.3.9, “Comparison of B-Tree and Hash Indexes”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#explain-output" title="8.8.2 EXPLAIN Output Format">Section 8.8.2, “EXPLAIN Output Format”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#extensions-to-ansi" title="1.8.1 MySQL Extensions to Standard SQL">Section 1.8.1, “MySQL Extensions to Standard SQL”</a></dt><dd></dd><dt><a class="xref" href="functions.html#operator-precedence" title="12.3.1 Operator Precedence">Section 12.3.1, “Operator Precedence”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#generated-column-index-optimizations" title="8.3.11 Optimizer Use of Generated Column Indexes">Section 8.3.11, “Optimizer Use of Generated Column Indexes”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#range-optimization" title="8.2.1.2 Range Optimization">Section 8.2.1.2, “Range Optimization”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#json" title="11.6 The JSON Data Type">Section 11.6, “The JSON Data Type”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">&lt;</h3>
<dl><dt><a class="xref" href="functions.html#comparison-operators" title="12.3.2 Comparison Functions and Operators">Section 12.3.2, “Comparison Functions and Operators”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#index-btree-hash" title="8.3.9 Comparison of B-Tree and Hash Indexes">Section 8.3.9, “Comparison of B-Tree and Hash Indexes”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#explain-output" title="8.8.2 EXPLAIN Output Format">Section 8.8.2, “EXPLAIN Output Format”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#extensions-to-ansi" title="1.8.1 MySQL Extensions to Standard SQL">Section 1.8.1, “MySQL Extensions to Standard SQL”</a></dt><dd></dd><dt><a class="xref" href="functions.html#operator-precedence" title="12.3.1 Operator Precedence">Section 12.3.1, “Operator Precedence”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#generated-column-index-optimizations" title="8.3.11 Optimizer Use of Generated Column Indexes">Section 8.3.11, “Optimizer Use of Generated Column Indexes”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#range-optimization" title="8.2.1.2 Range Optimization">Section 8.2.1.2, “Range Optimization”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#json" title="11.6 The JSON Data Type">Section 11.6, “The JSON Data Type”</a></dt><dd></dd><dt><a class="xref" href="tutorial.html#working-with-null" title="3.3.4.6 Working with NULL Values">Section 3.3.4.6, “Working with NULL Values”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">&lt;&gt;</h3>
<dl><dt><a class="xref" href="functions.html#comparison-operators" title="12.3.2 Comparison Functions and Operators">Section 12.3.2, “Comparison Functions and Operators”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#explain-output" title="8.8.2 EXPLAIN Output Format">Section 8.8.2, “EXPLAIN Output Format”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#extensions-to-ansi" title="1.8.1 MySQL Extensions to Standard SQL">Section 1.8.1, “MySQL Extensions to Standard SQL”</a></dt><dd></dd><dt><a class="xref" href="functions.html#operator-precedence" title="12.3.1 Operator Precedence">Section 12.3.1, “Operator Precedence”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#range-optimization" title="8.2.1.2 Range Optimization">Section 8.2.1.2, “Range Optimization”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#json" title="11.6 The JSON Data Type">Section 11.6, “The JSON Data Type”</a></dt><dd></dd><dt><a class="xref" href="tutorial.html#working-with-null" title="3.3.4.6 Working with NULL Values">Section 3.3.4.6, “Working with NULL Values”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">&lt;&lt;</h3>
<dl><dt><a class="xref" href="functions.html#bit-functions" title="12.12 Bit Functions and Operators">Section 12.12, “Bit Functions and Operators”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#extensions-to-ansi" title="1.8.1 MySQL Extensions to Standard SQL">Section 1.8.1, “MySQL Extensions to Standard SQL”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-limitations" title="22.6 Restrictions and Limitations on Partitioning">Section 22.6, “Restrictions and Limitations on Partitioning”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">&lt;=</h3>
<dl><dt><a class="xref" href="functions.html#comparison-operators" title="12.3.2 Comparison Functions and Operators">Section 12.3.2, “Comparison Functions and Operators”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#index-btree-hash" title="8.3.9 Comparison of B-Tree and Hash Indexes">Section 8.3.9, “Comparison of B-Tree and Hash Indexes”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#explain-output" title="8.8.2 EXPLAIN Output Format">Section 8.8.2, “EXPLAIN Output Format”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#extensions-to-ansi" title="1.8.1 MySQL Extensions to Standard SQL">Section 1.8.1, “MySQL Extensions to Standard SQL”</a></dt><dd></dd><dt><a class="xref" href="functions.html#operator-precedence" title="12.3.1 Operator Precedence">Section 12.3.1, “Operator Precedence”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#generated-column-index-optimizations" title="8.3.11 Optimizer Use of Generated Column Indexes">Section 8.3.11, “Optimizer Use of Generated Column Indexes”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#range-optimization" title="8.2.1.2 Range Optimization">Section 8.2.1.2, “Range Optimization”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#json" title="11.6 The JSON Data Type">Section 11.6, “The JSON Data Type”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">&lt;=&gt;</h3>
<dl><dt><a class="xref" href="functions.html#comparison-operators" title="12.3.2 Comparison Functions and Operators">Section 12.3.2, “Comparison Functions and Operators”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#explain-output" title="8.8.2 EXPLAIN Output Format">Section 8.8.2, “EXPLAIN Output Format”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#extensions-to-ansi" title="1.8.1 MySQL Extensions to Standard SQL">Section 1.8.1, “MySQL Extensions to Standard SQL”</a></dt><dd></dd><dt><a class="xref" href="functions.html#operator-precedence" title="12.3.1 Operator Precedence">Section 12.3.1, “Operator Precedence”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#range-optimization" title="8.2.1.2 Range Optimization">Section 8.2.1.2, “Range Optimization”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#json" title="11.6 The JSON Data Type">Section 11.6, “The JSON Data Type”</a></dt><dd></dd><dt><a class="xref" href="functions.html#type-conversion" title="12.2 Type Conversion in Expression Evaluation">Section 12.2, “Type Conversion in Expression Evaluation”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">*</h3>
<dl><dt><a class="xref" href="functions.html#arithmetic-functions" title="12.6.1 Arithmetic Operators">Section 12.6.1, “Arithmetic Operators”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#numeric-type-overview" title="11.1.1 Numeric Type Overview">Section 11.1.1, “Numeric Type Overview”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-limitations" title="22.6 Restrictions and Limitations on Partitioning">Section 22.6, “Restrictions and Limitations on Partitioning”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">+</h3>
<dl><dt><a class="xref" href="functions.html#arithmetic-functions" title="12.6.1 Arithmetic Operators">Section 12.6.1, “Arithmetic Operators”</a></dt><dd></dd><dt><a class="xref" href="functions.html#cast-functions" title="12.10 Cast Functions and Operators">Section 12.10, “Cast Functions and Operators”</a></dt><dd></dd><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#numeric-type-overview" title="11.1.1 Numeric Type Overview">Section 11.1.1, “Numeric Type Overview”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-limitations" title="22.6 Restrictions and Limitations on Partitioning">Section 22.6, “Restrictions and Limitations on Partitioning”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">/</h3>
<dl><dt><a class="xref" href="functions.html#arithmetic-functions" title="12.6.1 Arithmetic Operators">Section 12.6.1, “Arithmetic Operators”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-limitations" title="22.6 Restrictions and Limitations on Partitioning">Section 22.6, “Restrictions and Limitations on Partitioning”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#server-system-variables" title="5.1.5 Server System Variables">Section 5.1.5, “Server System Variables”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">:=</h3>
<dl><dt><a class="xref" href="functions.html#assignment-operators" title="12.3.4 Assignment Operators">Section 12.3.4, “Assignment Operators”</a></dt><dd></dd><dt><a class="xref" href="functions.html#operator-precedence" title="12.3.1 Operator Precedence">Section 12.3.1, “Operator Precedence”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#set-variable" title="13.7.5.1 SET Syntax for Variable Assignment">Section 13.7.5.1, “SET Syntax for Variable Assignment”</a></dt><dd></dd><dt><a class="xref" href="language-structure.html#user-variables" title="9.4 User-Defined Variables">Section 9.4, “User-Defined Variables”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">=</h3>
<dl><dt><a class="xref" href="functions.html#assignment-operators" title="12.3.4 Assignment Operators">Section 12.3.4, “Assignment Operators”</a></dt><dd></dd><dt><a class="xref" href="functions.html#comparison-operators" title="12.3.2 Comparison Functions and Operators">Section 12.3.2, “Comparison Functions and Operators”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#index-btree-hash" title="8.3.9 Comparison of B-Tree and Hash Indexes">Section 8.3.9, “Comparison of B-Tree and Hash Indexes”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#explain-output" title="8.8.2 EXPLAIN Output Format">Section 8.8.2, “EXPLAIN Output Format”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#extensions-to-ansi" title="1.8.1 MySQL Extensions to Standard SQL">Section 1.8.1, “MySQL Extensions to Standard SQL”</a></dt><dd></dd><dt><a class="xref" href="functions.html#operator-precedence" title="12.3.1 Operator Precedence">Section 12.3.1, “Operator Precedence”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#generated-column-index-optimizations" title="8.3.11 Optimizer Use of Generated Column Indexes">Section 8.3.11, “Optimizer Use of Generated Column Indexes”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#range-optimization" title="8.2.1.2 Range Optimization">Section 8.2.1.2, “Range Optimization”</a></dt><dd></dd><dt><a class="xref" href="restrictions.html#subquery-restrictions" title="C.4 Restrictions on Subqueries">Section C.4, “Restrictions on Subqueries”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#set-variable" title="13.7.5.1 SET Syntax for Variable Assignment">Section 13.7.5.1, “SET Syntax for Variable Assignment”</a></dt><dd></dd><dt><a class="xref" href="functions.html#string-comparison-functions" title="12.5.1 String Comparison Functions">Section 12.5.1, “String Comparison Functions”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#json" title="11.6 The JSON Data Type">Section 11.6, “The JSON Data Type”</a></dt><dd></dd><dt><a class="xref" href="language-structure.html#user-variables" title="9.4 User-Defined Variables">Section 9.4, “User-Defined Variables”</a></dt><dd></dd><dt><a class="xref" href="tutorial.html#working-with-null" title="3.3.4.6 Working with NULL Values">Section 3.3.4.6, “Working with NULL Values”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">^</h3>
<dl><dt><a class="xref" href="functions.html#bit-functions" title="12.12 Bit Functions and Operators">Section 12.12, “Bit Functions and Operators”</a></dt><dd></dd><dt><a class="xref" href="language-structure.html#expressions" title="9.5 Expression Syntax">Section 9.5, “Expression Syntax”</a></dt><dd></dd><dt><a class="xref" href="functions.html#operator-precedence" title="12.3.1 Operator Precedence">Section 12.3.1, “Operator Precedence”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-limitations" title="22.6 Restrictions and Limitations on Partitioning">Section 22.6, “Restrictions and Limitations on Partitioning”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">|</h3>
<dl><dt><a class="xref" href="functions.html#bit-functions" title="12.12 Bit Functions and Operators">Section 12.12, “Bit Functions and Operators”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-limitations" title="22.6 Restrictions and Limitations on Partitioning">Section 22.6, “Restrictions and Limitations on Partitioning”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">||</h3>
<dl><dt><a class="xref" href="functions.html#string-functions-charset" title="12.5.3 Character Set and Collation of Function Results">Section 12.5.3, “Character Set and Collation of Function Results”</a></dt><dd></dd><dt><a class="xref" href="charset.html#charset-collate-precedence" title="10.8.2 COLLATE Clause Precedence">Section 10.8.2, “COLLATE Clause Precedence”</a></dt><dd></dd><dt><a class="xref" href="language-structure.html#expressions" title="9.5 Expression Syntax">Section 9.5, “Expression Syntax”</a></dt><dd></dd><dt><a class="xref" href="functions.html#logical-operators" title="12.3.3 Logical Operators">Section 12.3.3, “Logical Operators”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#extensions-to-ansi" title="1.8.1 MySQL Extensions to Standard SQL">Section 1.8.1, “MySQL Extensions to Standard SQL”</a></dt><dd></dd><dt><a class="xref" href="functions.html#operator-precedence" title="12.3.1 Operator Precedence">Section 12.3.1, “Operator Precedence”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#sql-mode" title="5.1.8 Server SQL Modes">Section 5.1.8, “Server SQL Modes”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">~</h3>
<dl><dt><a class="xref" href="functions.html#bit-functions" title="12.12 Bit Functions and Operators">Section 12.12, “Bit Functions and Operators”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-limitations" title="22.6 Restrictions and Limitations on Partitioning">Section 22.6, “Restrictions and Limitations on Partitioning”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<a name="op-index-A"></a><h3 class="title">A</h3>
<p>[<a class="link" href="dynindex-operator.html#op-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">AND</h3>
<dl><dt><a class="xref" href="optimization.html#index-btree-hash" title="8.3.9 Comparison of B-Tree and Hash Indexes">Section 8.3.9, “Comparison of B-Tree and Hash Indexes”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#create-table" title="13.1.18 CREATE TABLE Syntax">Section 13.1.18, “CREATE TABLE Syntax”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#index-merge-optimization" title="8.2.1.3 Index Merge Optimization">Section 8.2.1.3, “Index Merge Optimization”</a></dt><dd></dd><dt><a class="xref" href="functions.html#logical-operators" title="12.3.3 Logical Operators">Section 12.3.3, “Logical Operators”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#extensions-to-ansi" title="1.8.1 MySQL Extensions to Standard SQL">Section 1.8.1, “MySQL Extensions to Standard SQL”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#subquery-optimization-with-exists" title="8.2.2.4 Optimizing Subqueries with the EXISTS Strategy">Section 8.2.2.4, “Optimizing Subqueries with the EXISTS Strategy”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#semi-joins" title="8.2.2.1 Optimizing Subqueries, Derived Tables, View References, and Common Table Expressions with Semi-Join Transformations">Section 8.2.2.1, “Optimizing Subqueries, Derived Tables, View References, and Common Table
Expressions with Semi-Join Transformations”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#range-optimization" title="8.2.1.2 Range Optimization">Section 8.2.1.2, “Range Optimization”</a></dt><dd></dd><dt><a class="xref" href="restrictions.html#subquery-restrictions" title="C.4 Restrictions on Subqueries">Section C.4, “Restrictions on Subqueries”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#row-constructor-optimization" title="8.2.1.19 Row Constructor Expression Optimization">Section 8.2.1.19, “Row Constructor Expression Optimization”</a></dt><dd></dd><dt><a class="xref" href="tutorial.html#searching-on-two-keys" title="3.6.7 Searching on Two Keys">Section 3.6.7, “Searching on Two Keys”</a></dt><dd></dd><dt><a class="xref" href="document-store.html#mysql-shell-tutorial-javascript-table-select" title="20.3.5.2 Select Tables">Section 20.3.5.2, “Select Tables”</a></dt><dd></dd><dt><a class="xref" href="document-store.html#mysql-shell-tutorial-python-table-select" title="20.4.5.2 Select Tables">Section 20.4.5.2, “Select Tables”</a></dt><dd></dd><dt><a class="xref" href="tutorial.html#selecting-rows" title="3.3.4.2 Selecting Particular Rows">Section 3.3.4.2, “Selecting Particular Rows”</a></dt><dd></dd><dt><a class="xref" href="functions.html#string-comparison-functions" title="12.5.1 String Comparison Functions">Section 12.5.1, “String Comparison Functions”</a></dt><dd></dd><dt><a class="xref" href="stored-programs-views.html#view-algorithms" title="23.5.2 View Processing Algorithms">Section 23.5.2, “View Processing Algorithms”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<a name="op-index-B"></a><h3 class="title">B</h3>
<p>[<a class="link" href="dynindex-operator.html#op-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">BETWEEN</h3>
<dl><dt><a class="xref" href="functions.html#comparison-operators" title="12.3.2 Comparison Functions and Operators">Section 12.3.2, “Comparison Functions and Operators”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#index-btree-hash" title="8.3.9 Comparison of B-Tree and Hash Indexes">Section 8.3.9, “Comparison of B-Tree and Hash Indexes”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#explain-output" title="8.8.2 EXPLAIN Output Format">Section 8.8.2, “EXPLAIN Output Format”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#generated-column-index-optimizations" title="8.3.11 Optimizer Use of Generated Column Indexes">Section 8.3.11, “Optimizer Use of Generated Column Indexes”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#range-optimization" title="8.2.1.2 Range Optimization">Section 8.2.1.2, “Range Optimization”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#json" title="11.6 The JSON Data Type">Section 11.6, “The JSON Data Type”</a></dt><dd></dd><dt><a class="xref" href="functions.html#type-conversion" title="12.2 Type Conversion in Expression Evaluation">Section 12.2, “Type Conversion in Expression Evaluation”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">BINARY</h3>
<dl><dt><a class="xref" href="functions.html#bit-functions" title="12.12 Bit Functions and Operators">Section 12.12, “Bit Functions and Operators”</a></dt><dd></dd><dt><a class="xref" href="functions.html#cast-functions" title="12.10 Cast Functions and Operators">Section 12.10, “Cast Functions and Operators”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#optimize-character" title="8.4.2.2 Optimizing for Character and String Types">Section 8.4.2.2, “Optimizing for Character and String Types”</a></dt><dd></dd><dt><a class="xref" href="tutorial.html#pattern-matching" title="3.3.4.7 Pattern Matching">Section 3.3.4.7, “Pattern Matching”</a></dt><dd></dd><dt><a class="xref" href="tutorial.html#sorting-rows" title="3.3.4.4 Sorting Rows">Section 3.3.4.4, “Sorting Rows”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<a name="op-index-C"></a><h3 class="title">C</h3>
<p>[<a class="link" href="dynindex-operator.html#op-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">CASE</h3>
<dl><dt><a class="xref" href="sql-syntax.html#case" title="13.6.5.1 CASE Syntax">Section 13.6.5.1, “CASE Syntax”</a></dt><dd></dd><dt><a class="xref" href="functions.html#control-flow-functions" title="12.4 Control Flow Functions">Section 12.4, “Control Flow Functions”</a></dt><dd></dd><dt><a class="xref" href="language-structure.html#expressions" title="9.5 Expression Syntax">Section 9.5, “Expression Syntax”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#extensions-to-ansi" title="1.8.1 MySQL Extensions to Standard SQL">Section 1.8.1, “MySQL Extensions to Standard SQL”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">CASE value WHEN END</h3>
<dl><dt><a class="xref" href="functions.html#control-flow-functions" title="12.4 Control Flow Functions">Section 12.4, “Control Flow Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">CASE WHEN END</h3>
<dl><dt><a class="xref" href="functions.html#control-flow-functions" title="12.4 Control Flow Functions">Section 12.4, “Control Flow Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">CASE WHEN expr1 = expr2 THEN NULL ELSE expr1 END</h3>
<dl><dt><a class="xref" href="functions.html#control-flow-functions" title="12.4 Control Flow Functions">Section 12.4, “Control Flow Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">column-&gt;&gt;path</h3>
<dl><dt><a class="xref" href="functions.html#json-search-functions" title="12.16.3 Functions That Search JSON Values">Section 12.16.3, “Functions That Search JSON Values”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">column-&gt;path</h3>
<dl><dt><a class="xref" href="functions.html#json-search-functions" title="12.16.3 Functions That Search JSON Values">Section 12.16.3, “Functions That Search JSON Values”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#json" title="11.6 The JSON Data Type">Section 11.6, “The JSON Data Type”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<a name="op-index-D"></a><h3 class="title">D</h3>
<p>[<a class="link" href="dynindex-operator.html#op-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">DIV</h3>
<dl><dt><a class="xref" href="functions.html#arithmetic-functions" title="12.6.1 Arithmetic Operators">Section 12.6.1, “Arithmetic Operators”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-limitations" title="22.6 Restrictions and Limitations on Partitioning">Section 22.6, “Restrictions and Limitations on Partitioning”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<a name="op-index-E"></a><h3 class="title">E</h3>
<p>[<a class="link" href="dynindex-operator.html#op-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">expr BETWEEN min AND max</h3>
<dl><dt><a class="xref" href="functions.html#comparison-operators" title="12.3.2 Comparison Functions and Operators">Section 12.3.2, “Comparison Functions and Operators”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">expr LIKE pat</h3>
<dl><dt><a class="xref" href="functions.html#string-comparison-functions" title="12.5.1 String Comparison Functions">Section 12.5.1, “String Comparison Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">expr NOT BETWEEN min AND max</h3>
<dl><dt><a class="xref" href="functions.html#comparison-operators" title="12.3.2 Comparison Functions and Operators">Section 12.3.2, “Comparison Functions and Operators”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">expr NOT LIKE pat</h3>
<dl><dt><a class="xref" href="functions.html#string-comparison-functions" title="12.5.1 String Comparison Functions">Section 12.5.1, “String Comparison Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">expr NOT REGEXP pat</h3>
<dl><dt><a class="xref" href="functions.html#regexp" title="12.5.2 Regular Expressions">Section 12.5.2, “Regular Expressions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">expr NOT RLIKE pat</h3>
<dl><dt><a class="xref" href="functions.html#regexp" title="12.5.2 Regular Expressions">Section 12.5.2, “Regular Expressions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">expr REGEXP pat</h3>
<dl><dt><a class="xref" href="functions.html#regexp" title="12.5.2 Regular Expressions">Section 12.5.2, “Regular Expressions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">expr RLIKE pat</h3>
<dl><dt><a class="xref" href="functions.html#regexp" title="12.5.2 Regular Expressions">Section 12.5.2, “Regular Expressions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">expr1 SOUNDS LIKE expr2</h3>
<dl><dt><a class="xref" href="functions.html#string-functions" title="12.5 String Functions">Section 12.5, “String Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<a name="op-index-I"></a><h3 class="title">I</h3>
<p>[<a class="link" href="dynindex-operator.html#op-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">IS</h3>
<dl><dt><a class="xref" href="functions.html#operator-precedence" title="12.3.1 Operator Precedence">Section 12.3.1, “Operator Precedence”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">IS boolean_value</h3>
<dl><dt><a class="xref" href="functions.html#comparison-operators" title="12.3.2 Comparison Functions and Operators">Section 12.3.2, “Comparison Functions and Operators”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">IS NOT boolean_value</h3>
<dl><dt><a class="xref" href="functions.html#comparison-operators" title="12.3.2 Comparison Functions and Operators">Section 12.3.2, “Comparison Functions and Operators”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">IS NOT NULL</h3>
<dl><dt><a class="xref" href="functions.html#comparison-operators" title="12.3.2 Comparison Functions and Operators">Section 12.3.2, “Comparison Functions and Operators”</a></dt><dd></dd><dt><a class="xref" href="error-handling.html#problems-with-null" title="B.5.4.3 Problems with NULL Values">Section B.5.4.3, “Problems with NULL Values”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#range-optimization" title="8.2.1.2 Range Optimization">Section 8.2.1.2, “Range Optimization”</a></dt><dd></dd><dt><a class="xref" href="tutorial.html#working-with-null" title="3.3.4.6 Working with NULL Values">Section 3.3.4.6, “Working with NULL Values”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">IS NULL</h3>
<dl><dt><a class="xref" href="functions.html#comparison-operators" title="12.3.2 Comparison Functions and Operators">Section 12.3.2, “Comparison Functions and Operators”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#explain-output" title="8.8.2 EXPLAIN Output Format">Section 8.8.2, “EXPLAIN Output Format”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#is-null-optimization" title="8.2.1.12 IS NULL Optimization">Section 8.2.1.12, “IS NULL Optimization”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#subquery-optimization-with-exists" title="8.2.2.4 Optimizing Subqueries with the EXISTS Strategy">Section 8.2.2.4, “Optimizing Subqueries with the EXISTS Strategy”</a></dt><dd></dd><dt><a class="xref" href="error-handling.html#problems-with-null" title="B.5.4.3 Problems with NULL Values">Section B.5.4.3, “Problems with NULL Values”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#range-optimization" title="8.2.1.2 Range Optimization">Section 8.2.1.2, “Range Optimization”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#server-system-variables" title="5.1.5 Server System Variables">Section 5.1.5, “Server System Variables”</a></dt><dd></dd><dt><a class="xref" href="tutorial.html#working-with-null" title="3.3.4.6 Working with NULL Values">Section 3.3.4.6, “Working with NULL Values”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<a name="op-index-L"></a><h3 class="title">L</h3>
<p>[<a class="link" href="dynindex-operator.html#op-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">LIKE</h3>
<dl><dt><a class="xref" href="security.html#request-access" title="6.2.7 Access Control, Stage 2: Request Verification">Section 6.2.7, “Access Control, Stage 2: Request Verification”</a></dt><dd></dd><dt><a class="xref" href="functions.html#cast-functions" title="12.10 Cast Functions and Operators">Section 12.10, “Cast Functions and Operators”</a></dt><dd></dd><dt><a class="xref" href="charset.html#charset-mysql" title="10.2 Character Sets and Collations in MySQL">Section 10.2, “Character Sets and Collations in MySQL”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#index-btree-hash" title="8.3.9 Comparison of B-Tree and Hash Indexes">Section 8.3.9, “Comparison of B-Tree and Hash Indexes”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#extended-show" title="24.36 Extensions to SHOW Statements">Section 24.36, “Extensions to SHOW Statements”</a></dt><dd></dd><dt><a class="xref" href="functions.html#json-search-functions" title="12.16.3 Functions That Search JSON Values">Section 12.16.3, “Functions That Search JSON Values”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#help" title="13.8.3 HELP Syntax">Section 13.8.3, “HELP Syntax”</a></dt><dd></dd><dt><a class="xref" href="faqs.html#faqs-cjk" title="A.11 MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets">Section A.11, “MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean
Character Sets”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#extensions-to-ansi" title="1.8.1 MySQL Extensions to Standard SQL">Section 1.8.1, “MySQL Extensions to Standard SQL”</a></dt><dd></dd><dt><a class="xref" href="programs.html#mysql-server-side-help" title="4.5.1.4 mysql Server-Side Help">Section 4.5.1.4, “mysql Server-Side Help”</a></dt><dd></dd><dt><a class="xref" href="functions.html#operator-precedence" title="12.3.1 Operator Precedence">Section 12.3.1, “Operator Precedence”</a></dt><dd></dd><dt><a class="xref" href="tutorial.html#pattern-matching" title="3.3.4.7 Pattern Matching">Section 3.3.4.7, “Pattern Matching”</a></dt><dd></dd><dt><a class="xref" href="performance-schema.html#performance-schema-instrument-filtering" title="25.4.4 Pre-Filtering by Instrument">Section 25.4.4, “Pre-Filtering by Instrument”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#range-optimization" title="8.2.1.2 Range Optimization">Section 8.2.1.2, “Range Optimization”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-options-slave" title="17.1.6.3 Replication Slave Options and Variables">Section 17.1.6.3, “Replication Slave Options and Variables”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#show-character-set" title="13.7.6.3 SHOW CHARACTER SET Syntax">Section 13.7.6.3, “SHOW CHARACTER SET Syntax”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#show-collation" title="13.7.6.4 SHOW COLLATION Syntax">Section 13.7.6.4, “SHOW COLLATION Syntax”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#show-columns" title="13.7.6.5 SHOW COLUMNS Syntax">Section 13.7.6.5, “SHOW COLUMNS Syntax”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#show-databases" title="13.7.6.14 SHOW DATABASES Syntax">Section 13.7.6.14, “SHOW DATABASES Syntax”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#show-events" title="13.7.6.18 SHOW EVENTS Syntax">Section 13.7.6.18, “SHOW EVENTS Syntax”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#show-open-tables" title="13.7.6.24 SHOW OPEN TABLES Syntax">Section 13.7.6.24, “SHOW OPEN TABLES Syntax”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#show-procedure-status" title="13.7.6.28 SHOW PROCEDURE STATUS Syntax">Section 13.7.6.28, “SHOW PROCEDURE STATUS Syntax”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#show-status" title="13.7.6.35 SHOW STATUS Syntax">Section 13.7.6.35, “SHOW STATUS Syntax”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#show-table-status" title="13.7.6.36 SHOW TABLE STATUS Syntax">Section 13.7.6.36, “SHOW TABLE STATUS Syntax”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#show-tables" title="13.7.6.37 SHOW TABLES Syntax">Section 13.7.6.37, “SHOW TABLES Syntax”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#show-triggers" title="13.7.6.38 SHOW TRIGGERS Syntax">Section 13.7.6.38, “SHOW TRIGGERS Syntax”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#show-variables" title="13.7.6.39 SHOW VARIABLES Syntax">Section 13.7.6.39, “SHOW VARIABLES Syntax”</a></dt><dd></dd><dt><a class="xref" href="security.html#account-names" title="6.2.4 Specifying Account Names">Section 6.2.4, “Specifying Account Names”</a></dt><dd></dd><dt><a class="xref" href="functions.html#string-comparison-functions" title="12.5.1 String Comparison Functions">Section 12.5.1, “String Comparison Functions”</a></dt><dd></dd><dt><a class="xref" href="language-structure.html#string-literals" title="9.1.1 String Literals">Section 9.1.1, “String Literals”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#structured-system-variables" title="5.1.6.1 Structured System Variables">Section 5.1.6.1, “Structured System Variables”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#char" title="11.4.1 The CHAR and VARCHAR Types">Section 11.4.1, “The CHAR and VARCHAR Types”</a></dt><dd></dd><dt><a class="xref" href="sys-schema.html#sys-ps-setup-disable-consumer" title="26.4.4.5 The ps_setup_disable_consumer() Procedure">Section 26.4.4.5, “The ps_setup_disable_consumer() Procedure”</a></dt><dd></dd><dt><a class="xref" href="sys-schema.html#sys-ps-setup-disable-instrument" title="26.4.4.6 The ps_setup_disable_instrument() Procedure">Section 26.4.4.6, “The ps_setup_disable_instrument() Procedure”</a></dt><dd></dd><dt><a class="xref" href="sys-schema.html#sys-ps-setup-enable-consumer" title="26.4.4.9 The ps_setup_enable_consumer() Procedure">Section 26.4.4.9, “The ps_setup_enable_consumer() Procedure”</a></dt><dd></dd><dt><a class="xref" href="sys-schema.html#sys-ps-setup-enable-instrument" title="26.4.4.10 The ps_setup_enable_instrument() Procedure">Section 26.4.4.10, “The ps_setup_enable_instrument() Procedure”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#set" title="11.4.5 The SET Type">Section 11.4.5, “The SET Type”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#using-system-variables" title="5.1.6 Using System Variables">Section 5.1.6, “Using System Variables”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">LIKE '_A%'</h3>
<dl><dt><a class="xref" href="faqs.html#faqs-cjk" title="A.11 MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets">Section A.11, “MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean
Character Sets”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">LIKE 'pattern'</h3>
<dl><dt><a class="xref" href="optimization.html#range-optimization" title="8.2.1.2 Range Optimization">Section 8.2.1.2, “Range Optimization”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#show" title="13.7.6 SHOW Syntax">Section 13.7.6, “SHOW Syntax”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">LIKE ... ESCAPE</h3>
<dl><dt><a class="xref" href="error-handling.html#bugs" title="B.5.7 Known Issues in MySQL">Section B.5.7, “Known Issues in MySQL”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<a name="op-index-N"></a><h3 class="title">N</h3>
<p>[<a class="link" href="dynindex-operator.html#op-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">N % M</h3>
<dl><dt><a class="xref" href="functions.html#arithmetic-functions" title="12.6.1 Arithmetic Operators">Section 12.6.1, “Arithmetic Operators”</a></dt><dd></dd><dt><a class="xref" href="functions.html#mathematical-functions" title="12.6.2 Mathematical Functions">Section 12.6.2, “Mathematical Functions”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">N MOD M</h3>
<dl><dt><a class="xref" href="functions.html#arithmetic-functions" title="12.6.1 Arithmetic Operators">Section 12.6.1, “Arithmetic Operators”</a></dt><dd></dd><dt><a class="xref" href="functions.html#mathematical-functions" title="12.6.2 Mathematical Functions">Section 12.6.2, “Mathematical Functions”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">NOT</h3>
<dl><dt><a class="xref" href="functions.html#logical-operators" title="12.3.3 Logical Operators">Section 12.3.3, “Logical Operators”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#sql-mode" title="5.1.8 Server SQL Modes">Section 5.1.8, “Server SQL Modes”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">NOT LIKE</h3>
<dl><dt><a class="xref" href="tutorial.html#pattern-matching" title="3.3.4.7 Pattern Matching">Section 3.3.4.7, “Pattern Matching”</a></dt><dd></dd><dt><a class="xref" href="functions.html#string-comparison-functions" title="12.5.1 String Comparison Functions">Section 12.5.1, “String Comparison Functions”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">NOT REGEXP</h3>
<dl><dt><a class="xref" href="introduction.html#extensions-to-ansi" title="1.8.1 MySQL Extensions to Standard SQL">Section 1.8.1, “MySQL Extensions to Standard SQL”</a></dt><dd></dd><dt><a class="xref" href="functions.html#string-comparison-functions" title="12.5.1 String Comparison Functions">Section 12.5.1, “String Comparison Functions”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">NOT RLIKE</h3>
<dl><dt><a class="xref" href="functions.html#string-comparison-functions" title="12.5.1 String Comparison Functions">Section 12.5.1, “String Comparison Functions”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<a name="op-index-O"></a><h3 class="title">O</h3>
<p>[<a class="link" href="dynindex-operator.html#op-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">OR</h3>
<dl><dt><a class="xref" href="language-structure.html#expressions" title="9.5 Expression Syntax">Section 9.5, “Expression Syntax”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#grant" title="13.7.1.6 GRANT Syntax">Section 13.7.1.6, “GRANT Syntax”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#index-merge-optimization" title="8.2.1.3 Index Merge Optimization">Section 8.2.1.3, “Index Merge Optimization”</a></dt><dd></dd><dt><a class="xref" href="functions.html#logical-operators" title="12.3.3 Logical Operators">Section 12.3.3, “Logical Operators”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#extensions-to-ansi" title="1.8.1 MySQL Extensions to Standard SQL">Section 1.8.1, “MySQL Extensions to Standard SQL”</a></dt><dd></dd><dt><a class="xref" href="functions.html#operator-precedence" title="12.3.1 Operator Precedence">Section 12.3.1, “Operator Precedence”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#subquery-optimization-with-exists" title="8.2.2.4 Optimizing Subqueries with the EXISTS Strategy">Section 8.2.2.4, “Optimizing Subqueries with the EXISTS Strategy”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#range-optimization" title="8.2.1.2 Range Optimization">Section 8.2.1.2, “Range Optimization”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#row-constructor-optimization" title="8.2.1.19 Row Constructor Expression Optimization">Section 8.2.1.19, “Row Constructor Expression Optimization”</a></dt><dd></dd><dt><a class="xref" href="tutorial.html#searching-on-two-keys" title="3.6.7 Searching on Two Keys">Section 3.6.7, “Searching on Two Keys”</a></dt><dd></dd><dt><a class="xref" href="document-store.html#mysql-shell-tutorial-javascript-table-select" title="20.3.5.2 Select Tables">Section 20.3.5.2, “Select Tables”</a></dt><dd></dd><dt><a class="xref" href="document-store.html#mysql-shell-tutorial-python-table-select" title="20.4.5.2 Select Tables">Section 20.4.5.2, “Select Tables”</a></dt><dd></dd><dt><a class="xref" href="tutorial.html#selecting-rows" title="3.3.4.2 Selecting Particular Rows">Section 3.3.4.2, “Selecting Particular Rows”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#sql-mode" title="5.1.8 Server SQL Modes">Section 5.1.8, “Server SQL Modes”</a></dt><dd></dd><dt><a class="xref" href="functions.html#string-comparison-functions" title="12.5.1 String Comparison Functions">Section 12.5.1, “String Comparison Functions”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<a name="op-index-R"></a><h3 class="title">R</h3>
<p>[<a class="link" href="dynindex-operator.html#op-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">REGEXP</h3>
<dl><dt><a class="xref" href="introduction.html#extensions-to-ansi" title="1.8.1 MySQL Extensions to Standard SQL">Section 1.8.1, “MySQL Extensions to Standard SQL”</a></dt><dd></dd><dt><a class="xref" href="functions.html#operator-precedence" title="12.3.1 Operator Precedence">Section 12.3.1, “Operator Precedence”</a></dt><dd></dd><dt><a class="xref" href="tutorial.html#pattern-matching" title="3.3.4.7 Pattern Matching">Section 3.3.4.7, “Pattern Matching”</a></dt><dd></dd><dt><a class="xref" href="functions.html#regexp" title="12.5.2 Regular Expressions">Section 12.5.2, “Regular Expressions”</a></dt><dd></dd><dt><a class="xref" href="restrictions.html#charset-restrictions" title="C.7 Restrictions on Character Sets">Section C.7, “Restrictions on Character Sets”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#mysql-nutshell" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">RLIKE</h3>
<dl><dt><a class="xref" href="tutorial.html#pattern-matching" title="3.3.4.7 Pattern Matching">Section 3.3.4.7, “Pattern Matching”</a></dt><dd></dd><dt><a class="xref" href="functions.html#regexp" title="12.5.2 Regular Expressions">Section 12.5.2, “Regular Expressions”</a></dt><dd></dd><dt><a class="xref" href="restrictions.html#charset-restrictions" title="C.7 Restrictions on Character Sets">Section C.7, “Restrictions on Character Sets”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#mysql-nutshell" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<a name="op-index-X"></a><h3 class="title">X</h3>
<p>[<a class="link" href="dynindex-operator.html#op-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">XOR</h3>
<dl><dt><a class="xref" href="functions.html#group-by-functions" title="12.19.1 Aggregate (GROUP BY) Function Descriptions">Section 12.19.1, “Aggregate (GROUP BY) Function Descriptions”</a></dt><dd></dd><dt><a class="xref" href="functions.html#logical-operators" title="12.3.3 Logical Operators">Section 12.3.3, “Logical Operators”</a></dt><dd></dd></dl>
</div>

</div>

<div class="copyright-footer">

</div>
<div class="navfooter">
<hr>
<table width="100%" summary="Navigation footer">
<tr>
<td width="40%" align="left"><a accesskey="p" href="dynindex-jointype.html">Prev</a></td>
<td width="20%" align="center"><a accesskey="u" href="">Up</a></td>
<td width="40%" align="right"> <a accesskey="n" href="dynindex-option.html">Next</a></td>
</tr>
<tr>
<td width="40%" align="left" valign="top"> Join Types Index</td>
<td width="20%" align="center"><a accesskey="h" href="index.html">Home</a></td>
<td width="40%" align="right" valign="top"> Option Index</td>
</tr>
</table>
</div>
</body>
</html>
